Summary Data counts for airline per carrier per US City.
Learn more about where this data came from at https://www.openintro.org/data/index.php?data=airline_delay. Note, not all data sets have additional information.
| variable | label | Percent Missing Observations | data_type | Plausible Values |
|---|---|---|---|---|
| year | Year data collected | 0 | Numeric | [2019, 2020] |
| month | Numeric representation of the month | 0 | Numeric | [12, 12] |
| carrier | Carrier. | 0 | Categorical | 9E, AA, AS, B6, DL, EV, F9, G4, HA, MQ, NK, OH, OO, UA, WN, YV, YX |
| carrier_name | Carrier Name. | 0 | Categorical | Alaska Airlines Inc., Allegiant Air, American Airlines Inc., Delta Air Lines Inc., Endeavor Air Inc., Envoy Air, ExpressJet Airlines LLC, Frontier Airlines Inc., Hawaiian Airlines Inc., JetBlue Airways, Mesa Airlines Inc., PSA Airlines Inc., Republic Airline, SkyWest Airlines Inc., Southwest Airlines Co., Spirit Air Lines, United Air Lines Inc. |
| airport | Airport code. | 0 | Categorical | ABE, ABI, ABQ, ABR, ABY, ACK, ACT, ACV, ACY, ADK, ADQ, AEX, AGS, ALB, ALO, ALS, AMA, ANC, APN, ASE, ATL, ATW, ATY, AUS, AVL, AVP, AZA, AZO, BDL, BET, BFF, BFL, BFM, BGM, BGR, BHM, BIL, BIS, BJI, BLI, BLV, BMI, BNA, BOI, BOS, BPT, BQK, BQN, BRD, BRO, BRW, BTM, BTR, BTV, BUF, BUR, BWI, BZN, CAE, CAK, CDB, CDC, CDV, CGI, CHA, CHO, CHS, CID, CIU, CKB, CLE, CLL, CLT, CMH, CMI, CMX, CNY, COD, COS, COU, CPR, CRP, CRW, CSG, CVG, CWA, CYS, DAB, DAL, DAY, DBQ, DCA, DDC, DEC, DEN, DFW, DHN, DIK, DLH, DRO, DRT, DSM, DTW, DVL, EAR, EAU, ECP, EGE, EKO, ELM, ELP, ERI, ESC, EUG, EVV, EWN, EWR, EYW, FAI, FAR, FAT, FAY, FCA, FLG, FLL, FNT, FSD, FSM, FWA, GCC, GCK, GEG, GFK, GGG, GJT, GNV, GPT, GRB, GRI, GRK, GRR, GSO, GSP, GTF, GTR, GUC, GUM, HDN, HGR, HHH, HIB, HLN, HNL, HOB, HOU, HPN, HRL, HSV, HTS, HVN, HYS, IAD, IAG, IAH, ICT, IDA, ILM, IMT, IND, INL, ISP, ITH, ITO, JAC, JAN, JAX, JFK, JLN, JMS, JNU, JST, KOA, KTN, LAN, LAR, LAS, LAW, LAX, LBB, LBE, LBF, LBL, LCH, LCK, LEX, LFT, LGA, LGB, LIH, LIT, LNK, LRD, LSE, LWB, LWS, LYH, MAF, MBS, MCI, MCO, MDT, MDW, MEI, MEM, MFE, MFR, MGM, MHK, MHT, MIA, MKE, MKG, MLB, MLI, MLU, MMH, MOB, MOT, MQT, MRY, MSN, MSO, MSP, MSY, MTJ, MYR, OAJ, OAK, OGD, OGG, OGS, OKC, OMA, OME, ONT, ORD, ORF, ORH, OTH, OTZ, OWB, PAE, PAH, PBG, PBI, PDX, PGD, PGV, PHF, PHL, PHX, PIA, PIB, PIE, PIH, PIR, PIT, PLN, PNS, PPG, PRC, PSC, PSE, PSG, PSM, PSP, PUB, PVD, PVU, PWM, RAP, RDD, RDM, RDU, RFD, RHI, RIC, RIW, RKS, RNO, ROA, ROC, ROW, RST, RSW, SAF, SAN, SAT, SAV, SBA, SBN, SBP, SCC, SCE, SCK, SDF, SEA, SFB, SFO, SGF, SGU, SHD, SHR, SHV, SIT, SJC, SJT, SJU, SLC, SLN, SMF, SMX, SNA, SPI, SPN, SPS, SRQ, STC, STL, STS, STT, STX, SUN, SUX, SWF, SWO, SYR, TLH, TOL, TPA, TRI, TTN, TUL, TUS, TVC, TWF, TXK, TYR, TYS, UIN, USA, VCT, VEL, VLD, VPS, WRG, XNA, XWA, YAK, YUM |
| airport_name | Name of airport. | 0 | Categorical | Aberdeen, SD: Aberdeen Regional, Abilene, TX: Abilene Regional, Adak Island, AK: Adak, Aguadilla, PR: Rafael Hernandez, Akron, OH: Akron-Canton Regional, Alamosa, CO: San Luis Valley Regional/Bergman Field, Albany, GA: Southwest Georgia Regional, Albany, NY: Albany International, Albuquerque, NM: Albuquerque International Sunport, Alexandria, LA: Alexandria International, Allentown/Bethlehem/Easton, PA: Lehigh Valley International, Alpena, MI: Alpena County Regional, Amarillo, TX: Rick Husband Amarillo International, Anchorage, AK: Ted Stevens Anchorage International, Appleton, WI: Appleton International, Arcata/Eureka, CA: California Redwood Coast Humboldt County, Asheville, NC: Asheville Regional, Ashland, WV: Tri-State/Milton J. Ferguson Field, Aspen, CO: Aspen Pitkin County Sardy Field, Atlanta, GA: Hartsfield-Jackson Atlanta International, Atlantic City, NJ: Atlantic City International, Augusta, GA: Augusta Regional at Bush Field, Austin, TX: Austin - Bergstrom International, Bakersfield, CA: Meadows Field, Baltimore, MD: Baltimore/Washington International Thurgood Marshall, Bangor, ME: Bangor International, Barrow, AK: Wiley Post/Will Rogers Memorial, Baton Rouge, LA: Baton Rouge Metropolitan/Ryan Field, Beaumont/Port Arthur, TX: Jack Brooks Regional, Belleville, IL: Scott AFB/MidAmerica, Bellingham, WA: Bellingham International, Bemidji, MN: Bemidji Regional, Bend/Redmond, OR: Roberts Field, Bethel, AK: Bethel Airport, Billings, MT: Billings Logan International, Binghamton, NY: Greater Binghamton/Edwin A. Link Field, Birmingham, AL: Birmingham-Shuttlesworth International, Bismarck/Mandan, ND: Bismarck Municipal, Bloomington/Normal, IL: Central Il Regional Airport at Bloomington, Boise, ID: Boise Air Terminal, Boston, MA: Logan International, Bozeman, MT: Bozeman Yellowstone International, Brainerd, MN: Brainerd Lakes Regional, Bristol/Johnson City/Kingsport, TN: Tri Cities, Brownsville, TX: Brownsville South Padre Island International, Brunswick, GA: Brunswick Golden Isles, Buffalo, NY: Buffalo Niagara International, Burbank, CA: Bob Hope, Burlington, VT: Burlington International, Butte, MT: Bert Mooney, Cape Girardeau, MO: Cape Girardeau Regional, Casper, WY: Casper/Natrona County International, Cedar City, UT: Cedar City Regional, Cedar Rapids/Iowa City, IA: The Eastern Iowa, Champaign/Urbana, IL: University of Illinois/Willard, Charleston, SC: Charleston AFB/International, Charleston/Dunbar, WV: Yeager, Charlotte Amalie, VI: Cyril E King, Charlotte, NC: Charlotte Douglas International, Charlottesville, VA: Charlottesville Albemarle, Chattanooga, TN: Lovell Field, Cheyenne, WY: Cheyenne Regional/Jerry Olson Field, Chicago, IL: Chicago Midway International, Chicago, IL: Chicago O’Hare International, Christiansted, VI: Henry E. Rohlsen, Cincinnati, OH: Cincinnati/Northern Kentucky International, Clarksburg/Fairmont, WV: North Central West Virginia, Cleveland, OH: Cleveland-Hopkins International, Cody, WY: Yellowstone Regional, Cold Bay, AK: Cold Bay Airport, College Station/Bryan, TX: Easterwood Field, Colorado Springs, CO: City of Colorado Springs Municipal, Columbia, MO: Columbia Regional, Columbia, SC: Columbia Metropolitan, Columbus, GA: Columbus Airport, Columbus, MS: Golden Triangle Regional, Columbus, OH: John Glenn Columbus International, Columbus, OH: Rickenbacker International, Concord, NC: Concord Padgett Regional, Cordova, AK: Merle K Mudhole Smith, Corpus Christi, TX: Corpus Christi International, Dallas, TX: Dallas Love Field, Dallas/Fort Worth, TX: Dallas/Fort Worth International, Dayton, OH: James M Cox/Dayton International, Daytona Beach, FL: Daytona Beach International, Deadhorse, AK: Deadhorse Airport, Decatur, IL: Decatur Airport, Del Rio, TX: Del Rio International, Denver, CO: Denver International, Des Moines, IA: Des Moines International, Detroit, MI: Detroit Metro Wayne County, Devils Lake, ND: Devils Lake Regional, Dickinson, ND: Dickinson - Theodore Roosevelt Regional, Dodge City, KS: Dodge City Regional, Dothan, AL: Dothan Regional, Dubuque, IA: Dubuque Regional, Duluth, MN: Duluth International, Durango, CO: Durango La Plata County, Eagle, CO: Eagle County Regional, Eau Claire, WI: Chippewa Valley Regional, El Paso, TX: El Paso International, Elko, NV: Elko Regional, Elmira/Corning, NY: Elmira/Corning Regional, Erie, PA: Erie International/Tom Ridge Field, Escanaba, MI: Delta County, Eugene, OR: Mahlon Sweet Field, Evansville, IN: Evansville Regional, Everett, WA: Snohomish County, Fairbanks, AK: Fairbanks International, Fargo, ND: Hector International, Fayetteville, AR: Northwest Arkansas Regional, Fayetteville, NC: Fayetteville Regional/Grannis Field, Flagstaff, AZ: Flagstaff Pulliam, Flint, MI: Bishop International, Fort Lauderdale, FL: Fort Lauderdale-Hollywood International, Fort Myers, FL: Southwest Florida International, Fort Smith, AR: Fort Smith Regional, Fort Wayne, IN: Fort Wayne International, Fresno, CA: Fresno Yosemite International, Gainesville, FL: Gainesville Regional, Garden City, KS: Garden City Regional, Gillette, WY: Gillette Campbell County, Grand Forks, ND: Grand Forks International, Grand Island, NE: Central Nebraska Regional, Grand Junction, CO: Grand Junction Regional, Grand Rapids, MI: Gerald R. Ford International, Great Falls, MT: Great Falls International, Green Bay, WI: Green Bay Austin Straubel International, Greensboro/High Point, NC: Piedmont Triad International, Greenville, NC: Pitt Greenville, Greer, SC: Greenville-Spartanburg International, Guam, TT: Guam International, Gulfport/Biloxi, MS: Gulfport-Biloxi International, Gunnison, CO: Gunnison-Crested Butte Regional, Hagerstown, MD: Hagerstown Regional-Richard A. Henson Field, Hancock/Houghton, MI: Houghton County Memorial, Harlingen/San Benito, TX: Valley International, Harrisburg, PA: Harrisburg International, Hartford, CT: Bradley International, Hattiesburg/Laurel, MS: Hattiesburg-Laurel Regional, Hayden, CO: Yampa Valley, Hays, KS: Hays Regional, Helena, MT: Helena Regional, Hibbing, MN: Range Regional, Hilo, HI: Hilo International, Hilton Head, SC: Hilton Head Airport, Hobbs, NM: Lea County Regional, Honolulu, HI: Daniel K Inouye International, Houston, TX: George Bush Intercontinental/Houston, Houston, TX: William P Hobby, Huntsville, AL: Huntsville International-Carl T Jones Field, Idaho Falls, ID: Idaho Falls Regional, Indianapolis, IN: Indianapolis International, International Falls, MN: Falls International Einarson Field, Iron Mountain/Kingsfd, MI: Ford, Islip, NY: Long Island MacArthur, Ithaca/Cortland, NY: Ithaca Tompkins Regional, Jackson, WY: Jackson Hole, Jackson/Vicksburg, MS: Jackson Medgar Wiley Evers International, Jacksonville, FL: Jacksonville International, Jacksonville/Camp Lejeune, NC: Albert J Ellis, Jamestown, ND: Jamestown Regional, Johnstown, PA: John Murtha Johnstown-Cambria County, Joplin, MO: Joplin Regional, Juneau, AK: Juneau International, Kahului, HI: Kahului Airport, Kalamazoo, MI: Kalamazoo/Battle Creek International, Kalispell, MT: Glacier Park International, Kansas City, MO: Kansas City International, Kearney, NE: Kearney Regional, Ketchikan, AK: Ketchikan International, Key West, FL: Key West International, Killeen, TX: Robert Gray AAF, Knoxville, TN: McGhee Tyson, Kodiak, AK: Kodiak Airport, Kona, HI: Ellison Onizuka Kona International at Keahole, Kotzebue, AK: Ralph Wien Memorial, La Crosse, WI: La Crosse Regional, Lafayette, LA: Lafayette Regional Paul Fournet Field, Lake Charles, LA: Lake Charles Regional, Lansing, MI: Capital Region International, Laramie, WY: Laramie Regional, Laredo, TX: Laredo International, Las Vegas, NV: McCarran International, Latrobe, PA: Arnold Palmer Regional, Lawton/Fort Sill, OK: Lawton-Fort Sill Regional, Lewisburg, WV: Greenbrier Valley, Lewiston, ID: Lewiston Nez Perce County, Lexington, KY: Blue Grass, Liberal, KS: Liberal Mid-America Regional, Lihue, HI: Lihue Airport, Lincoln, NE: Lincoln Airport, Little Rock, AR: Bill and Hillary Clinton Nat Adams Field, Long Beach, CA: Long Beach Airport, Longview, TX: East Texas Regional, Los Angeles, CA: Los Angeles International, Louisville, KY: Louisville Muhammad Ali International, Lubbock, TX: Lubbock Preston Smith International, Lynchburg, VA: Lynchburg Regional/Preston Glenn Field, Madison, WI: Dane County Regional-Truax Field, Mammoth Lakes, CA: Mammoth Lakes Airport, Manchester, NH: Manchester-Boston Regional, Manhattan/Ft. Riley, KS: Manhattan Regional, Marquette, MI: Sawyer International, Medford, OR: Rogue Valley International - Medford, Melbourne, FL: Melbourne International, Memphis, TN: Memphis International, Meridian, MS: Key Field, Miami, FL: Miami International, Midland/Odessa, TX: Midland International Air and Space Port, Milwaukee, WI: General Mitchell International, Minneapolis, MN: Minneapolis-St Paul International, Minot, ND: Minot International, Mission/McAllen/Edinburg, TX: McAllen Miller International, Missoula, MT: Missoula International, Moab, UT: Canyonlands Field, Mobile, AL: Mobile Downtown, Mobile, AL: Mobile Regional, Moline, IL: Quad City International, Monroe, LA: Monroe Regional, Monterey, CA: Monterey Regional, Montgomery, AL: Montgomery Regional, Montrose/Delta, CO: Montrose Regional, Mosinee, WI: Central Wisconsin, Muskegon, MI: Muskegon County, Myrtle Beach, SC: Myrtle Beach International, Nantucket, MA: Nantucket Memorial, Nashville, TN: Nashville International, New Bern/Morehead/Beaufort, NC: Coastal Carolina Regional, New Haven, CT: Tweed New Haven, New Orleans, LA: Louis Armstrong New Orleans International, New York, NY: John F. Kennedy International, New York, NY: LaGuardia, Newark, NJ: Newark Liberty International, Newburgh/Poughkeepsie, NY: New York Stewart International, Newport News/Williamsburg, VA: Newport News/Williamsburg International, Niagara Falls, NY: Niagara Falls International, Nome, AK: Nome Airport, Norfolk, VA: Norfolk International, North Bend/Coos Bay, OR: Southwest Oregon Regional, North Platte, NE: North Platte Regional Airport Lee Bird Field, Oakland, CA: Metropolitan Oakland International, Ogden, UT: Ogden-Hinckley, Ogdensburg, NY: Ogdensburg International, Oklahoma City, OK: Will Rogers World, Omaha, NE: Eppley Airfield, Ontario, CA: Ontario International, Orlando, FL: Orlando International, Owensboro, KY: Owensboro Daviess County Regional, Paducah, KY: Barkley Regional, Pago Pago, TT: Pago Pago International, Palm Springs, CA: Palm Springs International, Panama City, FL: Northwest Florida Beaches International, Pasco/Kennewick/Richland, WA: Tri Cities, Pellston, MI: Pellston Regional Airport of Emmet County, Pensacola, FL: Pensacola International, Peoria, IL: General Downing - Peoria International, Petersburg, AK: Petersburg James A Johnson, Philadelphia, PA: Philadelphia International, Phoenix, AZ: Phoenix - Mesa Gateway, Phoenix, AZ: Phoenix Sky Harbor International, Pierre, SD: Pierre Regional, Pittsburgh, PA: Pittsburgh International, Plattsburgh, NY: Plattsburgh International, Pocatello, ID: Pocatello Regional, Ponce, PR: Mercedita, Portland, ME: Portland International Jetport, Portland, OR: Portland International, Portsmouth, NH: Portsmouth International at Pease, Prescott, AZ: Prescott Regional Ernest A Love Field, Providence, RI: Theodore Francis Green State, Provo, UT: Provo Municipal, Pueblo, CO: Pueblo Memorial, Punta Gorda, FL: Punta Gorda Airport, Quincy, IL: Quincy Regional-Baldwin Field, Raleigh/Durham, NC: Raleigh-Durham International, Rapid City, SD: Rapid City Regional, Redding, CA: Redding Municipal, Reno, NV: Reno/Tahoe International, Rhinelander, WI: Rhinelander/Oneida County, Richmond, VA: Richmond International, Riverton/Lander, WY: Riverton Regional, Roanoke, VA: Roanoke Blacksburg Regional Woodrum Field, Rochester, MN: Rochester International, Rochester, NY: Greater Rochester International, Rock Springs, WY: Southwest Wyoming Regional, Rockford, IL: Chicago/Rockford International, Roswell, NM: Roswell International Air Center, Sacramento, CA: Sacramento International, Saginaw/Bay City/Midland, MI: MBS International, Saipan, TT: Francisco C. Ada Saipan International, Salina, KS: Salina Regional, Salt Lake City, UT: Salt Lake City International, San Angelo, TX: San Angelo Regional/Mathis Field, San Antonio, TX: San Antonio International, San Diego, CA: San Diego International, San Francisco, CA: San Francisco International, San Jose, CA: Norman Y. Mineta San Jose International, San Juan, PR: Luis Munoz Marin International, San Luis Obispo, CA: San Luis County Regional, Sanford, FL: Orlando Sanford International, Santa Ana, CA: John Wayne Airport-Orange County, Santa Barbara, CA: Santa Barbara Municipal, Santa Fe, NM: Santa Fe Municipal, Santa Maria, CA: Santa Maria Public/Capt. G. Allan Hancock Field, Santa Rosa, CA: Charles M. Schulz - Sonoma County, Sarasota/Bradenton, FL: Sarasota/Bradenton International, Sault Ste. Marie, MI: Chippewa County International, Savannah, GA: Savannah/Hilton Head International, Scottsbluff, NE: Western Neb. Regional/William B. Heilig Field, Scranton/Wilkes-Barre, PA: Wilkes Barre Scranton International, Seattle, WA: Seattle/Tacoma International, Sheridan, WY: Sheridan County, Shreveport, LA: Shreveport Regional, Sioux City, IA: Sioux Gateway Brig Gen Bud Day Field, Sioux Falls, SD: Joe Foss Field, Sitka, AK: Sitka Rocky Gutierrez, South Bend, IN: South Bend International, Spokane, WA: Spokane International, Springfield, IL: Abraham Lincoln Capital, Springfield, MO: Springfield-Branson National, St. Cloud, MN: St. Cloud Regional, St. George, UT: St George Regional, St. Louis, MO: St Louis Lambert International, St. Petersburg, FL: St Pete Clearwater International, State College, PA: University Park, Staunton, VA: Shenandoah Valley Regional, Stillwater, OK: Stillwater Regional, Stockton, CA: Stockton Metropolitan, Sun Valley/Hailey/Ketchum, ID: Friedman Memorial, Syracuse, NY: Syracuse Hancock International, Tallahassee, FL: Tallahassee International, Tampa, FL: Tampa International, Texarkana, AR: Texarkana Regional-Webb Field, Toledo, OH: Toledo Express, Traverse City, MI: Cherry Capital, Trenton, NJ: Trenton Mercer, Tucson, AZ: Tucson International, Tulsa, OK: Tulsa International, Twin Falls, ID: Joslin Field - Magic Valley Regional, Tyler, TX: Tyler Pounds Regional, Valdosta, GA: Valdosta Regional, Valparaiso, FL: Eglin AFB Destin Fort Walton Beach, Vernal, UT: Vernal Regional, Victoria, TX: Victoria Regional, Waco, TX: Waco Regional, Washington, DC: Ronald Reagan Washington National, Washington, DC: Washington Dulles International, Waterloo, IA: Waterloo Regional, Watertown, SD: Watertown Regional, West Palm Beach/Palm Beach, FL: Palm Beach International, White Plains, NY: Westchester County, Wichita Falls, TX: Sheppard AFB/Wichita Falls Municipal, Wichita, KS: Wichita Dwight D Eisenhower National, Williston, ND: Williston Basin International, Wilmington, NC: Wilmington International, Worcester, MA: Worcester Regional, Wrangell, AK: Wrangell Airport, Yakutat, AK: Yakutat Airport, Yuma, AZ: Yuma MCAS/Yuma International |
| arr_flights | Number of flights arriving at airport | 0 | Numeric | [1, 19713] |
| arr_del15 | Number of flights more than 15 minutes late | 0 | Numeric | [0, 2289] |
| carrier_ct | Number of flights delayed due to air carrier. (e.g. no crew) | 0 | Numeric | [0, 697] |
| weather_ct | Number of flights due to weather. | 0 | Numeric | [0, 89.42] |
| nas_ct | Number of flights delayed due to National Aviation System (e.g. heavy air traffic). | 0 | Numeric | [0, 1039.54] |
| security_ct | Number of flights canceled due to a security breach. | 0 | Numeric | [0, 17.31] |
| late_aircraft_ct | Number of flights delayed as a result of another flight on the same aircraft delayed | 0 | Numeric | [0, 819.66] |
| arr_cancelled | Number of cancelled flights | 0 | Numeric | [0, 224] |
| arr_diverted | Number of flights that were diverted | 0 | Numeric | [0, 42] |
| arr_delay | Total time (minutes) of delayed flight. | 0 | Numeric | [0, 160383] |
| carrier_delay | Total time (minutes) of delay due to air carrier | 0 | Numeric | [0, 55215] |
| weather_delay | Total time (minutes) of delay due to inclement weather. | 0 | Numeric | [0, 14219] |
| nas_delay | Total time (minutes) of delay due to National Aviation System. | 0 | Numeric | [0, 82064] |
| security_delay | Total time (minutes) of delay as a result of a security issue . | 0 | Numeric | [0, 553] |
| late_aircraft_delay | Total time (minutes) of delay flights as a result of a previous flight on the same airplane being late. | 0 | Numeric | [0, 75179] |